**************************************************************************************
* Bemærk at denne fil kun er til orientering om databaseændringer til denne release. *
* Filen MÅ IKKE afvikles!                                                            *
**************************************************************************************

IF EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'DuVisitation' AND cname = 'modtagetRelevantInformationOmDeltagelse') THEN
   ALTER TABLE DuVisitation DROP modtagetRelevantInformationOmDeltagelse;
END IF;

update PersonGruppe set medarbejderPersonnummer = null where not exists (select 1 from medarbejder where medarbejderPersonnummer = personnummer); commit;
IF NOT EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'PersonGruppe' and role = 'medarbejder') THEN
   ALTER TABLE PersonGruppe ADD FOREIGN KEY medarbejder(medarbejderPersonnummer) REFERENCES Medarbejder(personnummer) ON UPDATE CASCADE ON DELETE SET NULL;
END IF;

IF NOT EXISTS (SELECT 1 FROM LUDUSWebProperty WHERE propertyName = 'XPRS_IPL_KONFIGURATION') THEN
INSERT INTO LUDUSWebProperty (propertyName, value)
SELECT
    'XPRS_IPL_KONFIGURATION',
    '{"institutionsnummer":"' || (SELECT institutionKode FROM SystemIndstillinger) ||
    '","xprsUsername":"' || (SELECT xprsUserId FROM SystemIndstillinger) ||
    '","xprsPassword":"' || (SELECT xprsPassword FROM SystemIndstillinger) ||
    '","wsIndberetningURL":"https://integrationsplatformen.dk/services/XPRS/Indberetning/v3.0' ||
    '","wsIndberetningstatusURL":"https://integrationsplatformen.dk/services/XPRS/IndberetningStatus/v1.0' ||
    '","wsUdmeldingURL":"https://integrationsplatformen.dk/services/XPRS/Udmelding/v2.0' ||
    '","wsOpslagURL":"https://integrationsplatformen.dk/services/XPRS/Opslag/v1.0' ||
    '"}';
commit;
END IF;
QUIT